<?php
/*
  $Id: specials.php 1739 2007-12-20 00:52:16Z hpdl $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/


$new_products_query = tep_db_query("select distinct p.products_id, p.products_model,p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_status = '1' and p.featured = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_id desc limit 6" );



$docs = array();
$rows = 0;
  while ($listing = tep_db_fetch_array($new_products_query)) {
$rows ++;
$listing['url'] = cc_strformat($listing['products_name'])."-p-".$listing["products_id"].".html";
$docs[] = $listing;

  }


  /*if ($random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) {*/
?>
<!-- specials //-->


<?php
    $info_box_contents = array();
    $info_box_contents[] = array('text' => BOX_HEADING_SPECIALS);

    //new infoBoxHeading($info_box_contents, false, false, tep_href_link(FILENAME_SPECIALS));

    /*$info_box_contents = array();
    $info_box_contents[] = array('align' => 'center',
                                 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product["products_id"]) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a><br><s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</span>');*/

    //new infoBox($info_box_contents);


   foreach($docs as $key=>$random_product){



	?>

<tr>
                    <td class="news_text"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="70"><img src="<?php echo DIR_WS_IMAGES . $random_product['products_image'];?>" width="60" height="60" hspace="5" border="0" /></td>
                        <td><span class="style29"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a>';?></span> <br />
                            <span class="style10">MSRP <br />
                              <?php echo $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) ;?></span></td>
                        <td width="21"><img src="images/19.jpg" width="21" height="62" /></td>
                      </tr>
                    </table></td>
                  </tr>

<tr>
                    <td class="news_text"><img src="images/16.jpg" width="170" height="11" /></td>
                  </tr>

	<?php

   }
?>







<!-- specials_eof //-->
<?php
  //}
?>
